Previous Topic

Next Topic

Using Ad Hoc Searches

Ad hoc searches allow refinement of the standard report search criteria used to select specific records needed for a report. After the search is defined, the search instructions are saved in a list of predefined search formats for future use. Depending upon the selected report, you can define your search by using multiple tables.

You can specify selections based on multiple-field comparisons from one or more files. The files that are available for selection depend on the module and the menu function you choose.

Ad hoc searches can be as simple as one line searches that look for an exact match on values in a single field or as complex as a multiple-line item or multiple-group search. You can have up to 50 criteria for each selection. This search function supports extremely complicated queries, and supports Boolean logic statements as well as AND and OR connections.

Note: For selection between values, such as dates, combine the Greater than and Less than conditions.

In This Section

To create an ad hoc search

Modifying an Existing Ad hoc Search

Examples of Ad Hoc Searches

Managing Ad Hoc Searches

See Also

Standard iMIS Reporting Capabilities

Using Standard iMIS Reporting Tools

Running a Standard Report

Modifying a Standard Report

Cloning a Report (Permanent Report Modifications)

Clearing old query results

Printing Bar Codes

Exporting Report Data

Generating and Managing Mass Report Activity Records

Using the QuickLetter System for Letter Reports

Using the MS Word Letter System for Letter Reports


ASI logo 10.6 Production Release. Updated 7/20/2005 2:18:32 PM
© 2009 by Advanced Solutions International, Inc. All rights reserved.